SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create view [dbo].[matriculajorge]
as
select cuise,aniolectivo, count (alumno)as matricula from tb_alumnodivision inner join tb_divisionestemp on tb_alumnodivision.division = iddivision group by aniolectivo,cuise


GO
